﻿CREATE PROCEDURE [dbo].[usp_Currency_Tbl_Ins] 
	@Currency nvarchar(50),
	@CurrSymbol nvarchar(50),
	@ExRate float,
	@ExDate nvarchar(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

INSERT INTO Currency_Tbl (Currency, CurrencySymbol, ExRate, ExchangeDate) VALUES (@Currency, @CurrSymbol, @ExRate, @ExDate)
END